Dataset statistics
| Number of variables | 21 |
|---|---|
| Number of observations | 8920 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 1.4 MiB |
| Average record size in memory | 164.0 B |
Variable types
| Numeric | 21 |
|---|
df_index is highly correlated with cust_id | High correlation |
cust_id is highly correlated with df_index | High correlation |
balance is highly correlated with balance_frequency and 5 other fields | High correlation |
balance_frequency is highly correlated with balance and 1 other fields | High correlation |
purchases is highly correlated with oneoff_purchases and 6 other fields | High correlation |
oneoff_purchases is highly correlated with purchases and 3 other fields | High correlation |
installments_purchases is highly correlated with purchases and 3 other fields | High correlation |
cash_advance is highly correlated with balance and 3 other fields | High correlation |
purchases_frequency is highly correlated with purchases and 3 other fields | High correlation |
oneoff_purchases_frequency is highly correlated with purchases and 3 other fields | High correlation |
purchases_installments_frequency is highly correlated with purchases and 3 other fields | High correlation |
cash_advance_frequency is highly correlated with balance and 3 other fields | High correlation |
cash_advance_trx is highly correlated with balance and 3 other fields | High correlation |
purchases_trx is highly correlated with purchases and 5 other fields | High correlation |
minimum_payments is highly correlated with balance and 1 other fields | High correlation |
purchases_avg is highly correlated with purchases and 2 other fields | High correlation |
cash_advance_avg is highly correlated with balance and 3 other fields | High correlation |
df_index is highly correlated with cust_id | High correlation |
cust_id is highly correlated with df_index | High correlation |
balance is highly correlated with credit_limit | High correlation |
purchases is highly correlated with oneoff_purchases and 3 other fields | High correlation |
oneoff_purchases is highly correlated with purchases and 3 other fields | High correlation |
installments_purchases is highly correlated with purchases and 2 other fields | High correlation |
cash_advance is highly correlated with cash_advance_frequency and 1 other fields | High correlation |
purchases_frequency is highly correlated with oneoff_purchases_frequency and 2 other fields | High correlation |
oneoff_purchases_frequency is highly correlated with oneoff_purchases and 2 other fields | High correlation |
purchases_installments_frequency is highly correlated with installments_purchases and 2 other fields | High correlation |
cash_advance_frequency is highly correlated with cash_advance and 1 other fields | High correlation |
cash_advance_trx is highly correlated with cash_advance and 1 other fields | High correlation |
purchases_trx is highly correlated with purchases and 5 other fields | High correlation |
credit_limit is highly correlated with balance | High correlation |
payments is highly correlated with purchases and 1 other fields | High correlation |
df_index is highly correlated with cust_id | High correlation |
cust_id is highly correlated with df_index | High correlation |
balance is highly correlated with minimum_payments | High correlation |
purchases is highly correlated with oneoff_purchases and 5 other fields | High correlation |
oneoff_purchases is highly correlated with purchases and 2 other fields | High correlation |
installments_purchases is highly correlated with purchases and 3 other fields | High correlation |
cash_advance is highly correlated with cash_advance_frequency and 2 other fields | High correlation |
purchases_frequency is highly correlated with purchases and 3 other fields | High correlation |
oneoff_purchases_frequency is highly correlated with purchases and 1 other fields | High correlation |
purchases_installments_frequency is highly correlated with installments_purchases and 2 other fields | High correlation |
cash_advance_frequency is highly correlated with cash_advance and 2 other fields | High correlation |
cash_advance_trx is highly correlated with cash_advance and 2 other fields | High correlation |
purchases_trx is highly correlated with purchases and 3 other fields | High correlation |
minimum_payments is highly correlated with balance | High correlation |
purchases_avg is highly correlated with purchases and 1 other fields | High correlation |
cash_advance_avg is highly correlated with cash_advance and 2 other fields | High correlation |
df_index is highly correlated with cust_id | High correlation |
cust_id is highly correlated with df_index | High correlation |
balance is highly correlated with credit_limit | High correlation |
purchases is highly correlated with oneoff_purchases and 4 other fields | High correlation |
oneoff_purchases is highly correlated with purchases and 2 other fields | High correlation |
installments_purchases is highly correlated with purchases and 1 other fields | High correlation |
cash_advance is highly correlated with cash_advance_trx and 1 other fields | High correlation |
purchases_frequency is highly correlated with oneoff_purchases_frequency and 1 other fields | High correlation |
oneoff_purchases_frequency is highly correlated with purchases_frequency | High correlation |
purchases_installments_frequency is highly correlated with purchases_frequency | High correlation |
cash_advance_frequency is highly correlated with cash_advance_trx | High correlation |
cash_advance_trx is highly correlated with cash_advance and 1 other fields | High correlation |
purchases_trx is highly correlated with purchases and 3 other fields | High correlation |
credit_limit is highly correlated with balance and 2 other fields | High correlation |
payments is highly correlated with purchases and 5 other fields | High correlation |
purchases_avg is highly correlated with payments | High correlation |
df_index is uniformly distributed | Uniform |
cust_id is uniformly distributed | Uniform |
df_index has unique values | Unique |
cust_id has unique values | Unique |
purchases has 2038 (22.8%) zeros | Zeros |
oneoff_purchases has 4283 (48.0%) zeros | Zeros |
installments_purchases has 3904 (43.8%) zeros | Zeros |
cash_advance has 4612 (51.7%) zeros | Zeros |
purchases_frequency has 2038 (22.8%) zeros | Zeros |
oneoff_purchases_frequency has 4283 (48.0%) zeros | Zeros |
purchases_installments_frequency has 3904 (43.8%) zeros | Zeros |
cash_advance_frequency has 4612 (51.7%) zeros | Zeros |
cash_advance_trx has 4612 (51.7%) zeros | Zeros |
purchases_trx has 2036 (22.8%) zeros | Zeros |
payments has 240 (2.7%) zeros | Zeros |
minimum_payments has 313 (3.5%) zeros | Zeros |
prc_full_payment has 5878 (65.9%) zeros | Zeros |
purchases_avg has 2038 (22.8%) zeros | Zeros |
cash_advance_avg has 4612 (51.7%) zeros | Zeros |
Reproduction
| Analysis started | 2021-11-30 12:49:31.838214 |
|---|---|
| Analysis finished | 2021-11-30 12:51:16.243143 |
| Duration | 1 minute and 44.4 seconds |
| Software version | pandas-profiling v3.1.0 |
| Download configuration | config.json |
df_index
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONUNIFORMUNIQUE| Distinct | 8920 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4474.136883 |
| Minimum | 0 |
|---|---|
| Maximum | 8949 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 69.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 445.95 |
| Q1 | 2236.75 |
| median | 4472.5 |
| Q3 | 6712.25 |
| 95-th percentile | 8502.05 |
| Maximum | 8949 |
| Range | 8949 |
| Interquartile range (IQR) | 4475.5 |
Descriptive statistics
| Standard deviation | 2584.092911 |
|---|---|
| Coefficient of variation (CV) | 0.5775623272 |
| Kurtosis | -1.200105095 |
| Mean | 4474.136883 |
| Median Absolute Deviation (MAD) | 2237.5 |
| Skewness | 0.0003342727901 |
| Sum | 39909301 |
| Variance | 6677536.171 |
| Monotonicity | Strictly increasing |
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 605 | 1 | < 0.1% |
| 2644 | 1 | < 0.1% |
| 597 | 1 | < 0.1% |
| 6742 | 1 | < 0.1% |
| 4695 | 1 | < 0.1% |
| 8793 | 1 | < 0.1% |
| 2652 | 1 | < 0.1% |
| 6750 | 1 | < 0.1% |
| 2668 | 1 | < 0.1% |
| Other values (8910) | 8910 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 |
| Value | Count | Frequency (%) |
| 8949 | 1 | |
| 8948 | 1 | |
| 8947 | 1 | |
| 8946 | 1 | |
| 8945 | 1 | |
| 8944 | 1 | |
| 8943 | 1 | |
| 8942 | 1 | |
| 8941 | 1 | |
| 8940 | 1 |
cust_id
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONUNIFORMUNIQUE| Distinct | 8920 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 14599.66637 |
| Minimum | 10001 |
|---|---|
| Maximum | 19190 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 35.0 KiB |
Quantile statistics
| Minimum | 10001 |
|---|---|
| 5-th percentile | 10461.95 |
| Q1 | 12306.75 |
| median | 14596.5 |
| Q3 | 16900.25 |
| 95-th percentile | 18733.05 |
| Maximum | 19190 |
| Range | 9189 |
| Interquartile range (IQR) | 4593.5 |
Descriptive statistics
| Standard deviation | 2651.620337 |
|---|---|
| Coefficient of variation (CV) | 0.1816219816 |
| Kurtosis | -1.199360604 |
| Mean | 14599.66637 |
| Median Absolute Deviation (MAD) | 2296.5 |
| Skewness | -0.0004945342566 |
| Sum | 130229024 |
| Variance | 7031090.412 |
| Monotonicity | Strictly increasing |
| Value | Count | Frequency (%) |
| 16384 | 1 | < 0.1% |
| 14922 | 1 | < 0.1% |
| 10816 | 1 | < 0.1% |
| 14914 | 1 | < 0.1% |
| 12867 | 1 | < 0.1% |
| 19012 | 1 | < 0.1% |
| 16965 | 1 | < 0.1% |
| 10824 | 1 | < 0.1% |
| 12875 | 1 | < 0.1% |
| 10840 | 1 | < 0.1% |
| Other values (8910) | 8910 |
| Value | Count | Frequency (%) |
| 10001 | 1 | |
| 10002 | 1 | |
| 10003 | 1 | |
| 10004 | 1 | |
| 10005 | 1 | |
| 10006 | 1 | |
| 10007 | 1 | |
| 10008 | 1 | |
| 10009 | 1 | |
| 10010 | 1 |
| Value | Count | Frequency (%) |
| 19190 | 1 | |
| 19189 | 1 | |
| 19188 | 1 | |
| 19187 | 1 | |
| 19186 | 1 | |
| 19185 | 1 | |
| 19184 | 1 | |
| 19183 | 1 | |
| 19182 | 1 | |
| 19181 | 1 |
| Distinct | 8841 |
|---|---|
| Distinct (%) | 99.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1562.512922 |
| Minimum | 0 |
|---|---|
| Maximum | 19043.13856 |
| Zeros | 80 |
| Zeros (%) | 0.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 69.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 8.82004985 |
| Q1 | 128.3728552 |
| median | 871.534477 |
| Q3 | 2049.707459 |
| 95-th percentile | 5906.232841 |
| Maximum | 19043.13856 |
| Range | 19043.13856 |
| Interquartile range (IQR) | 1921.334604 |
Descriptive statistics
| Standard deviation | 2079.408643 |
|---|---|
| Coefficient of variation (CV) | 1.330810525 |
| Kurtosis | 7.714122828 |
| Mean | 1562.512922 |
| Median Absolute Deviation (MAD) | 798.3892365 |
| Skewness | 2.397770669 |
| Sum | 13937615.27 |
| Variance | 4323940.304 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 80 | 0.9% |
| 74.825456 | 1 | < 0.1% |
| 155.676255 | 1 | < 0.1% |
| 34.750769 | 1 | < 0.1% |
| 2643.343414 | 1 | < 0.1% |
| 6366.085376 | 1 | < 0.1% |
| 1112.915657 | 1 | < 0.1% |
| 2545.614986 | 1 | < 0.1% |
| 449.026889 | 1 | < 0.1% |
| 1722.910058 | 1 | < 0.1% |
| Other values (8831) | 8831 |
| Value | Count | Frequency (%) |
| 0 | 80 | |
| 0.000199 | 1 | < 0.1% |
| 0.001146 | 1 | < 0.1% |
| 0.001214 | 1 | < 0.1% |
| 0.001289 | 1 | < 0.1% |
| 0.004816 | 1 | < 0.1% |
| 0.006651 | 1 | < 0.1% |
| 0.009684 | 1 | < 0.1% |
| 0.01968 | 1 | < 0.1% |
| 0.021102 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 19043.13856 | 1 | |
| 18495.55855 | 1 | |
| 16304.88925 | 1 | |
| 16259.44857 | 1 | |
| 16115.5964 | 1 | |
| 15532.33972 | 1 | |
| 15258.2259 | 1 | |
| 15244.74865 | 1 | |
| 15155.53286 | 1 | |
| 14581.45914 | 1 |
| Distinct | 43 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.8772435415 |
| Minimum | 0 |
|---|---|
| Maximum | 1 |
| Zeros | 80 |
| Zeros (%) | 0.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 69.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.272727 |
| Q1 | 0.888889 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 1 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range (IQR) | 0.111111 |
Descriptive statistics
| Standard deviation | 0.2369232478 |
|---|---|
| Coefficient of variation (CV) | 0.270076936 |
| Kurtosis | 3.096858681 |
| Mean | 0.8772435415 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -2.023939108 |
| Sum | 7825.01239 |
| Variance | 0.05613262536 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 6189 | |
| 0.909091 | 408 | 4.6% |
| 0.818182 | 278 | 3.1% |
| 0.727273 | 223 | 2.5% |
| 0.545455 | 219 | 2.5% |
| 0.636364 | 209 | 2.3% |
| 0.363636 | 170 | 1.9% |
| 0.454545 | 169 | 1.9% |
| 0.272727 | 149 | 1.7% |
| 0.181818 | 146 | 1.6% |
| Other values (33) | 760 | 8.5% |
| Value | Count | Frequency (%) |
| 0 | 80 | |
| 0.090909 | 67 | |
| 0.1 | 8 | 0.1% |
| 0.111111 | 5 | 0.1% |
| 0.125 | 9 | 0.1% |
| 0.142857 | 7 | 0.1% |
| 0.166667 | 7 | 0.1% |
| 0.181818 | 146 | |
| 0.2 | 9 | 0.1% |
| 0.222222 | 5 | 0.1% |
| Value | Count | Frequency (%) |
| 1 | 6189 | |
| 0.909091 | 408 | 4.6% |
| 0.9 | 55 | 0.6% |
| 0.888889 | 53 | 0.6% |
| 0.875 | 57 | 0.6% |
| 0.857143 | 51 | 0.6% |
| 0.833333 | 59 | 0.7% |
| 0.818182 | 278 | 3.1% |
| 0.8 | 20 | 0.2% |
| 0.777778 | 22 | 0.2% |
purchases
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 6180 |
|---|---|
| Distinct (%) | 69.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1004.733073 |
| Minimum | 0 |
|---|---|
| Maximum | 49039.57 |
| Zeros | 2038 |
| Zeros (%) | 22.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 69.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 39.57 |
| median | 362.305 |
| Q3 | 1112.425 |
| 95-th percentile | 4000.009 |
| Maximum | 49039.57 |
| Range | 49039.57 |
| Interquartile range (IQR) | 1072.855 |
Descriptive statistics
| Standard deviation | 2139.075941 |
|---|---|
| Coefficient of variation (CV) | 2.128999233 |
| Kurtosis | 111.2247759 |
| Mean | 1004.733073 |
| Median Absolute Deviation (MAD) | 362.305 |
| Skewness | 8.140453832 |
| Sum | 8962219.01 |
| Variance | 4575645.883 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 2038 | 22.8% |
| 45.65 | 27 | 0.3% |
| 60 | 16 | 0.2% |
| 150 | 16 | 0.2% |
| 300 | 13 | 0.1% |
| 100 | 13 | 0.1% |
| 200 | 13 | 0.1% |
| 450 | 12 | 0.1% |
| 70 | 10 | 0.1% |
| 120 | 10 | 0.1% |
| Other values (6170) | 6752 |
| Value | Count | Frequency (%) |
| 0 | 2038 | |
| 0.01 | 4 | < 0.1% |
| 0.05 | 1 | < 0.1% |
| 0.7 | 1 | < 0.1% |
| 1 | 2 | < 0.1% |
| 1.4 | 1 | < 0.1% |
| 2 | 1 | < 0.1% |
| 4.44 | 1 | < 0.1% |
| 4.8 | 1 | < 0.1% |
| 4.99 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 49039.57 | 1 | |
| 41050.4 | 1 | |
| 40040.71 | 1 | |
| 38902.71 | 1 | |
| 35131.16 | 1 | |
| 32539.78 | 1 | |
| 31299.35 | 1 | |
| 27957.68 | 1 | |
| 27790.42 | 1 | |
| 26784.62 | 1 |
oneoff_purchases
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 4004 |
|---|---|
| Distinct (%) | 44.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 593.7731491 |
| Minimum | 0 |
|---|---|
| Maximum | 40761.25 |
| Zeros | 4283 |
| Zeros (%) | 48.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 69.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 39 |
| Q3 | 581.015 |
| 95-th percentile | 2675.0315 |
| Maximum | 40761.25 |
| Range | 40761.25 |
| Interquartile range (IQR) | 581.015 |
Descriptive statistics
| Standard deviation | 1662.139174 |
|---|---|
| Coefficient of variation (CV) | 2.799283154 |
| Kurtosis | 163.8101308 |
| Mean | 593.7731491 |
| Median Absolute Deviation (MAD) | 39 |
| Skewness | 10.0351636 |
| Sum | 5296456.49 |
| Variance | 2762706.633 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 4283 | |
| 45.65 | 45 | 0.5% |
| 50 | 17 | 0.2% |
| 200 | 15 | 0.2% |
| 60 | 13 | 0.1% |
| 100 | 13 | 0.1% |
| 1000 | 12 | 0.1% |
| 70 | 12 | 0.1% |
| 150 | 12 | 0.1% |
| 250 | 11 | 0.1% |
| Other values (3994) | 4487 |
| Value | Count | Frequency (%) |
| 0 | 4283 | |
| 0.01 | 7 | 0.1% |
| 0.02 | 2 | < 0.1% |
| 0.05 | 1 | < 0.1% |
| 0.7 | 1 | < 0.1% |
| 1 | 4 | < 0.1% |
| 1.4 | 2 | < 0.1% |
| 2 | 1 | < 0.1% |
| 4.99 | 1 | < 0.1% |
| 5 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 40761.25 | 1 | |
| 40624.06 | 1 | |
| 34087.73 | 1 | |
| 33803.84 | 1 | |
| 26547.43 | 1 | |
| 26514.32 | 1 | |
| 25122.77 | 1 | |
| 24543.52 | 1 | |
| 23032.97 | 1 | |
| 22257.39 | 1 |
installments_purchases
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 4437 |
|---|---|
| Distinct (%) | 49.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 410.9599238 |
| Minimum | 0 |
|---|---|
| Maximum | 22500 |
| Zeros | 3904 |
| Zeros (%) | 43.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 69.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 89.18 |
| Q3 | 467.34 |
| 95-th percentile | 1753.284 |
| Maximum | 22500 |
| Range | 22500 |
| Interquartile range (IQR) | 467.34 |
Descriptive statistics
| Standard deviation | 903.5509971 |
|---|---|
| Coefficient of variation (CV) | 2.198635305 |
| Kurtosis | 97.06942256 |
| Mean | 410.9599238 |
| Median Absolute Deviation (MAD) | 89.18 |
| Skewness | 7.313374299 |
| Sum | 3665762.52 |
| Variance | 816404.4044 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 3904 | |
| 200 | 14 | 0.2% |
| 100 | 14 | 0.2% |
| 300 | 14 | 0.2% |
| 150 | 12 | 0.1% |
| 125 | 11 | 0.1% |
| 75 | 9 | 0.1% |
| 450 | 8 | 0.1% |
| 350 | 8 | 0.1% |
| 500 | 8 | 0.1% |
| Other values (4427) | 4918 |
| Value | Count | Frequency (%) |
| 0 | 3904 | |
| 1.95 | 1 | < 0.1% |
| 4.44 | 1 | < 0.1% |
| 4.8 | 1 | < 0.1% |
| 6.33 | 1 | < 0.1% |
| 7.26 | 1 | < 0.1% |
| 7.67 | 1 | < 0.1% |
| 9.28 | 1 | < 0.1% |
| 9.58 | 1 | < 0.1% |
| 9.65 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 22500 | 1 | |
| 15497.19 | 1 | |
| 14686.1 | 1 | |
| 13184.43 | 1 | |
| 12738.47 | 1 | |
| 12560.85 | 1 | |
| 12541 | 1 | |
| 12375 | 1 | |
| 12235.05 | 1 | |
| 12128.94 | 1 |
cash_advance
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 4309 |
|---|---|
| Distinct (%) | 48.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 977.9975392 |
| Minimum | 0 |
|---|---|
| Maximum | 47137.21176 |
| Zeros | 4612 |
| Zeros (%) | 51.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 69.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1113.273292 |
| 95-th percentile | 4639.920152 |
| Maximum | 47137.21176 |
| Range | 47137.21176 |
| Interquartile range (IQR) | 1113.273292 |
Descriptive statistics
| Standard deviation | 2097.519305 |
|---|---|
| Coefficient of variation (CV) | 2.144708162 |
| Kurtosis | 53.0434044 |
| Mean | 977.9975392 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.176949006 |
| Sum | 8723738.05 |
| Variance | 4399587.234 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 4612 | |
| 920.309805 | 1 | < 0.1% |
| 724.694411 | 1 | < 0.1% |
| 1420.758241 | 1 | < 0.1% |
| 2081.583331 | 1 | < 0.1% |
| 2970.97936 | 1 | < 0.1% |
| 4353.620039 | 1 | < 0.1% |
| 8641.998958 | 1 | < 0.1% |
| 4962.936839 | 1 | < 0.1% |
| 3061.014837 | 1 | < 0.1% |
| Other values (4299) | 4299 |
| Value | Count | Frequency (%) |
| 0 | 4612 | |
| 14.222216 | 1 | < 0.1% |
| 18.042768 | 1 | < 0.1% |
| 18.117967 | 1 | < 0.1% |
| 18.123413 | 1 | < 0.1% |
| 18.126683 | 1 | < 0.1% |
| 18.149946 | 1 | < 0.1% |
| 18.204577 | 1 | < 0.1% |
| 18.240626 | 1 | < 0.1% |
| 18.280043 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 47137.21176 | 1 | |
| 29282.10915 | 1 | |
| 27296.48576 | 1 | |
| 26268.69989 | 1 | |
| 26194.04954 | 1 | |
| 23130.82106 | 1 | |
| 22665.7785 | 1 | |
| 21943.84942 | 1 | |
| 20712.67008 | 1 | |
| 20277.33112 | 1 |
purchases_frequency
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 47 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.4905560407 |
| Minimum | 0 |
|---|---|
| Maximum | 1 |
| Zeros | 2038 |
| Zeros (%) | 22.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 69.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0.083333 |
| median | 0.5 |
| Q3 | 0.916667 |
| 95-th percentile | 1 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range (IQR) | 0.833334 |
Descriptive statistics
| Standard deviation | 0.4014905514 |
|---|---|
| Coefficient of variation (CV) | 0.8184397256 |
| Kurtosis | -1.63936366 |
| Mean | 0.4905560407 |
| Median Absolute Deviation (MAD) | 0.416667 |
| Skewness | 0.05888288058 |
| Sum | 4375.759883 |
| Variance | 0.1611946628 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 2173 | |
| 0 | 2038 | |
| 0.083333 | 675 | 7.6% |
| 0.5 | 394 | 4.4% |
| 0.916667 | 394 | 4.4% |
| 0.166667 | 391 | 4.4% |
| 0.833333 | 372 | 4.2% |
| 0.333333 | 365 | 4.1% |
| 0.25 | 342 | 3.8% |
| 0.583333 | 315 | 3.5% |
| Other values (37) | 1461 |
| Value | Count | Frequency (%) |
| 0 | 2038 | |
| 0.083333 | 675 | 7.6% |
| 0.090909 | 43 | 0.5% |
| 0.1 | 26 | 0.3% |
| 0.111111 | 18 | 0.2% |
| 0.125 | 31 | 0.3% |
| 0.142857 | 26 | 0.3% |
| 0.166667 | 391 | 4.4% |
| 0.181818 | 16 | 0.2% |
| 0.2 | 19 | 0.2% |
| Value | Count | Frequency (%) |
| 1 | 2173 | |
| 0.916667 | 394 | 4.4% |
| 0.909091 | 28 | 0.3% |
| 0.9 | 24 | 0.3% |
| 0.888889 | 18 | 0.2% |
| 0.875 | 26 | 0.3% |
| 0.857143 | 25 | 0.3% |
| 0.833333 | 372 | 4.2% |
| 0.818182 | 21 | 0.2% |
| 0.8 | 9 | 0.1% |
oneoff_purchases_frequency
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 47 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.202867074 |
| Minimum | 0 |
|---|---|
| Maximum | 1 |
| Zeros | 4283 |
| Zeros (%) | 48.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 69.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0.083333 |
| Q3 | 0.3 |
| 95-th percentile | 1 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range (IQR) | 0.3 |
Descriptive statistics
| Standard deviation | 0.2986539051 |
|---|---|
| Coefficient of variation (CV) | 1.472165489 |
| Kurtosis | 1.149099359 |
| Mean | 0.202867074 |
| Median Absolute Deviation (MAD) | 0.083333 |
| Skewness | 1.532304114 |
| Sum | 1809.5743 |
| Variance | 0.08919415504 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 4283 | |
| 0.083333 | 1101 | 12.3% |
| 0.166667 | 592 | 6.6% |
| 1 | 481 | 5.4% |
| 0.25 | 415 | 4.7% |
| 0.333333 | 354 | 4.0% |
| 0.416667 | 244 | 2.7% |
| 0.5 | 234 | 2.6% |
| 0.583333 | 197 | 2.2% |
| 0.666667 | 167 | 1.9% |
| Other values (37) | 852 | 9.6% |
| Value | Count | Frequency (%) |
| 0 | 4283 | |
| 0.083333 | 1101 | 12.3% |
| 0.090909 | 56 | 0.6% |
| 0.1 | 38 | 0.4% |
| 0.111111 | 26 | 0.3% |
| 0.125 | 40 | 0.4% |
| 0.142857 | 37 | 0.4% |
| 0.166667 | 592 | 6.6% |
| 0.181818 | 34 | 0.4% |
| 0.2 | 27 | 0.3% |
| Value | Count | Frequency (%) |
| 1 | 481 | |
| 0.916667 | 151 | 1.7% |
| 0.909091 | 4 | < 0.1% |
| 0.9 | 1 | < 0.1% |
| 0.888889 | 2 | < 0.1% |
| 0.875 | 6 | 0.1% |
| 0.857143 | 1 | < 0.1% |
| 0.833333 | 120 | 1.3% |
| 0.818182 | 10 | 0.1% |
| 0.8 | 4 | < 0.1% |
purchases_installments_frequency
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 47 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.3644958629 |
| Minimum | 0 |
|---|---|
| Maximum | 1 |
| Zeros | 3904 |
| Zeros (%) | 43.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 69.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0.166667 |
| Q3 | 0.75 |
| 95-th percentile | 1 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range (IQR) | 0.75 |
Descriptive statistics
| Standard deviation | 0.3974575441 |
|---|---|
| Coefficient of variation (CV) | 1.090430879 |
| Kurtosis | -1.3991404 |
| Mean | 0.3644958629 |
| Median Absolute Deviation (MAD) | 0.166667 |
| Skewness | 0.5086379574 |
| Sum | 3251.303097 |
| Variance | 0.1579724994 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 3904 | |
| 1 | 1326 | 14.9% |
| 0.416667 | 388 | 4.3% |
| 0.916667 | 344 | 3.9% |
| 0.833333 | 310 | 3.5% |
| 0.5 | 309 | 3.5% |
| 0.166667 | 303 | 3.4% |
| 0.666667 | 291 | 3.3% |
| 0.75 | 290 | 3.3% |
| 0.083333 | 271 | 3.0% |
| Other values (37) | 1184 | 13.3% |
| Value | Count | Frequency (%) |
| 0 | 3904 | |
| 0.083333 | 271 | 3.0% |
| 0.090909 | 12 | 0.1% |
| 0.1 | 6 | 0.1% |
| 0.111111 | 9 | 0.1% |
| 0.125 | 5 | 0.1% |
| 0.142857 | 6 | 0.1% |
| 0.166667 | 303 | 3.4% |
| 0.181818 | 14 | 0.2% |
| 0.2 | 9 | 0.1% |
| Value | Count | Frequency (%) |
| 1 | 1326 | |
| 0.916667 | 344 | 3.9% |
| 0.909091 | 25 | 0.3% |
| 0.9 | 19 | 0.2% |
| 0.888889 | 28 | 0.3% |
| 0.875 | 28 | 0.3% |
| 0.857143 | 30 | 0.3% |
| 0.833333 | 310 | 3.5% |
| 0.818182 | 21 | 0.2% |
| 0.8 | 18 | 0.2% |
cash_advance_frequency
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 47 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.1343701601 |
| Minimum | 0 |
|---|---|
| Maximum | 1 |
| Zeros | 4612 |
| Zeros (%) | 51.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 69.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0.222222 |
| 95-th percentile | 0.583333 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range (IQR) | 0.222222 |
Descriptive statistics
| Standard deviation | 0.1977454896 |
|---|---|
| Coefficient of variation (CV) | 1.471647347 |
| Kurtosis | 2.886218301 |
| Mean | 0.1343701601 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.769252535 |
| Sum | 1198.581828 |
| Variance | 0.03910327864 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 4612 | |
| 0.083333 | 1018 | 11.4% |
| 0.166667 | 759 | 8.5% |
| 0.25 | 577 | 6.5% |
| 0.333333 | 438 | 4.9% |
| 0.416667 | 273 | 3.1% |
| 0.5 | 215 | 2.4% |
| 0.583333 | 141 | 1.6% |
| 0.666667 | 125 | 1.4% |
| 0.090909 | 70 | 0.8% |
| Other values (37) | 692 | 7.8% |
| Value | Count | Frequency (%) |
| 0 | 4612 | |
| 0.083333 | 1018 | 11.4% |
| 0.090909 | 70 | 0.8% |
| 0.1 | 39 | 0.4% |
| 0.111111 | 29 | 0.3% |
| 0.125 | 47 | 0.5% |
| 0.142857 | 49 | 0.5% |
| 0.166667 | 759 | 8.5% |
| 0.181818 | 42 | 0.5% |
| 0.2 | 21 | 0.2% |
| Value | Count | Frequency (%) |
| 1 | 25 | |
| 0.916667 | 27 | |
| 0.909091 | 3 | < 0.1% |
| 0.9 | 2 | < 0.1% |
| 0.888889 | 2 | < 0.1% |
| 0.875 | 5 | 0.1% |
| 0.857143 | 5 | 0.1% |
| 0.833333 | 48 | |
| 0.818182 | 2 | < 0.1% |
| 0.8 | 6 | 0.1% |
cash_advance_trx
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 65 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.239461883 |
| Minimum | 0 |
|---|---|
| Maximum | 123 |
| Zeros | 4612 |
| Zeros (%) | 51.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 69.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 4 |
| 95-th percentile | 15 |
| Maximum | 123 |
| Range | 123 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 6.814954483 |
|---|---|
| Coefficient of variation (CV) | 2.103730412 |
| Kurtosis | 62.21440988 |
| Mean | 3.239461883 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.752721811 |
| Sum | 28896 |
| Variance | 46.4436046 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 4612 | |
| 1 | 886 | 9.9% |
| 2 | 619 | 6.9% |
| 3 | 436 | 4.9% |
| 4 | 382 | 4.3% |
| 5 | 307 | 3.4% |
| 6 | 246 | 2.8% |
| 7 | 205 | 2.3% |
| 8 | 171 | 1.9% |
| 10 | 149 | 1.7% |
| Other values (55) | 907 | 10.2% |
| Value | Count | Frequency (%) |
| 0 | 4612 | |
| 1 | 886 | 9.9% |
| 2 | 619 | 6.9% |
| 3 | 436 | 4.9% |
| 4 | 382 | 4.3% |
| 5 | 307 | 3.4% |
| 6 | 246 | 2.8% |
| 7 | 205 | 2.3% |
| 8 | 171 | 1.9% |
| 9 | 111 | 1.2% |
| Value | Count | Frequency (%) |
| 123 | 3 | |
| 110 | 1 | < 0.1% |
| 107 | 1 | < 0.1% |
| 93 | 1 | < 0.1% |
| 80 | 1 | < 0.1% |
| 71 | 1 | < 0.1% |
| 69 | 1 | < 0.1% |
| 63 | 1 | < 0.1% |
| 62 | 3 | |
| 61 | 1 | < 0.1% |
purchases_trx
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 173 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 14.72466368 |
| Minimum | 0 |
|---|---|
| Maximum | 358 |
| Zeros | 2036 |
| Zeros (%) | 22.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 69.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 7 |
| Q3 | 17 |
| 95-th percentile | 57 |
| Maximum | 358 |
| Range | 358 |
| Interquartile range (IQR) | 16 |
Descriptive statistics
| Standard deviation | 24.87834234 |
|---|---|
| Coefficient of variation (CV) | 1.689569479 |
| Kurtosis | 34.77673531 |
| Mean | 14.72466368 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | 4.630671453 |
| Sum | 131344 |
| Variance | 618.9319177 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 2036 | |
| 1 | 665 | 7.5% |
| 12 | 570 | 6.4% |
| 2 | 376 | 4.2% |
| 6 | 350 | 3.9% |
| 3 | 313 | 3.5% |
| 4 | 285 | 3.2% |
| 7 | 274 | 3.1% |
| 8 | 267 | 3.0% |
| 5 | 263 | 2.9% |
| Other values (163) | 3521 |
| Value | Count | Frequency (%) |
| 0 | 2036 | |
| 1 | 665 | 7.5% |
| 2 | 376 | 4.2% |
| 3 | 313 | 3.5% |
| 4 | 285 | 3.2% |
| 5 | 263 | 2.9% |
| 6 | 350 | 3.9% |
| 7 | 274 | 3.1% |
| 8 | 267 | 3.0% |
| 9 | 248 | 2.8% |
| Value | Count | Frequency (%) |
| 358 | 1 | |
| 347 | 1 | |
| 344 | 1 | |
| 309 | 1 | |
| 308 | 1 | |
| 298 | 1 | |
| 274 | 1 | |
| 273 | 1 | |
| 254 | 1 | |
| 248 | 2 |
| Distinct | 205 |
|---|---|
| Distinct (%) | 2.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4492.51997 |
| Minimum | 50 |
|---|---|
| Maximum | 30000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 69.8 KiB |
Quantile statistics
| Minimum | 50 |
|---|---|
| 5-th percentile | 1000 |
| Q1 | 1600 |
| median | 3000 |
| Q3 | 6500 |
| 95-th percentile | 12000 |
| Maximum | 30000 |
| Range | 29950 |
| Interquartile range (IQR) | 4900 |
Descriptive statistics
| Standard deviation | 3638.641132 |
|---|---|
| Coefficient of variation (CV) | 0.8099332126 |
| Kurtosis | 2.845871581 |
| Mean | 4492.51997 |
| Median Absolute Deviation (MAD) | 1800 |
| Skewness | 1.523857227 |
| Sum | 40073278.13 |
| Variance | 13239709.29 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3000 | 781 | 8.8% |
| 1500 | 721 | 8.1% |
| 1200 | 619 | 6.9% |
| 2500 | 611 | 6.8% |
| 1000 | 610 | 6.8% |
| 4000 | 504 | 5.7% |
| 6000 | 461 | 5.2% |
| 5000 | 387 | 4.3% |
| 2000 | 370 | 4.1% |
| 7500 | 277 | 3.1% |
| Other values (195) | 3579 |
| Value | Count | Frequency (%) |
| 50 | 2 | < 0.1% |
| 150 | 5 | 0.1% |
| 200 | 3 | < 0.1% |
| 300 | 14 | 0.2% |
| 400 | 3 | < 0.1% |
| 450 | 6 | 0.1% |
| 500 | 121 | |
| 600 | 21 | 0.2% |
| 650 | 1 | < 0.1% |
| 700 | 20 | 0.2% |
| Value | Count | Frequency (%) |
| 30000 | 2 | < 0.1% |
| 28000 | 1 | < 0.1% |
| 25000 | 1 | < 0.1% |
| 23000 | 2 | < 0.1% |
| 22500 | 1 | < 0.1% |
| 22000 | 1 | < 0.1% |
| 21500 | 2 | < 0.1% |
| 21000 | 2 | < 0.1% |
| 20500 | 1 | < 0.1% |
| 20000 | 10 |
| Distinct | 8681 |
|---|---|
| Distinct (%) | 97.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1731.830582 |
| Minimum | 0 |
|---|---|
| Maximum | 50721.48336 |
| Zeros | 240 |
| Zeros (%) | 2.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 69.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 89.86248575 |
| Q1 | 383.280622 |
| median | 857.8868165 |
| Q3 | 1904.981381 |
| 95-th percentile | 6083.430983 |
| Maximum | 50721.48336 |
| Range | 50721.48336 |
| Interquartile range (IQR) | 1521.700759 |
Descriptive statistics
| Standard deviation | 2884.060385 |
|---|---|
| Coefficient of variation (CV) | 1.665324782 |
| Kurtosis | 54.96966457 |
| Mean | 1731.830582 |
| Median Absolute Deviation (MAD) | 582.176172 |
| Skewness | 5.90182428 |
| Sum | 15447928.79 |
| Variance | 8317804.306 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 240 | 2.7% |
| 282.414709 | 1 | < 0.1% |
| 817.050377 | 1 | < 0.1% |
| 284.093261 | 1 | < 0.1% |
| 1333.446631 | 1 | < 0.1% |
| 1265.31093 | 1 | < 0.1% |
| 453.19428 | 1 | < 0.1% |
| 3530.131795 | 1 | < 0.1% |
| 414.218007 | 1 | < 0.1% |
| 2857.881585 | 1 | < 0.1% |
| Other values (8671) | 8671 |
| Value | Count | Frequency (%) |
| 0 | 240 | |
| 0.049513 | 1 | < 0.1% |
| 0.056466 | 1 | < 0.1% |
| 2.389583 | 1 | < 0.1% |
| 3.500505 | 1 | < 0.1% |
| 4.523555 | 1 | < 0.1% |
| 4.841543 | 1 | < 0.1% |
| 5.070726 | 1 | < 0.1% |
| 9.040017 | 1 | < 0.1% |
| 9.533313 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 50721.48336 | 1 | |
| 46930.59824 | 1 | |
| 40627.59524 | 1 | |
| 39461.9658 | 1 | |
| 39048.59762 | 1 | |
| 36066.75068 | 1 | |
| 35843.62593 | 1 | |
| 34107.07499 | 1 | |
| 33994.72785 | 1 | |
| 33486.31044 | 1 |
| Distinct | 8607 |
|---|---|
| Distinct (%) | 96.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 834.2181165 |
| Minimum | 0 |
|---|---|
| Maximum | 76406.20752 |
| Zeros | 313 |
| Zeros (%) | 3.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 69.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 29.69426285 |
| Q1 | 163.0290433 |
| median | 289.514532 |
| Q3 | 787.173152 |
| 95-th percentile | 2722.274019 |
| Maximum | 76406.20752 |
| Range | 76406.20752 |
| Interquartile range (IQR) | 624.1441087 |
Descriptive statistics
| Standard deviation | 2339.137016 |
|---|---|
| Coefficient of variation (CV) | 2.803987314 |
| Kurtosis | 291.752683 |
| Mean | 834.2181165 |
| Median Absolute Deviation (MAD) | 188.4782655 |
| Skewness | 13.79779351 |
| Sum | 7441225.599 |
| Variance | 5471561.98 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 313 | 3.5% |
| 299.351881 | 2 | < 0.1% |
| 1340.320342 | 1 | < 0.1% |
| 160.863666 | 1 | < 0.1% |
| 210.156238 | 1 | < 0.1% |
| 200.106261 | 1 | < 0.1% |
| 25697.63772 | 1 | < 0.1% |
| 427.14706 | 1 | < 0.1% |
| 227.726516 | 1 | < 0.1% |
| 438.190574 | 1 | < 0.1% |
| Other values (8597) | 8597 |
| Value | Count | Frequency (%) |
| 0 | 313 | |
| 0.019163 | 1 | < 0.1% |
| 0.037744 | 1 | < 0.1% |
| 0.05588 | 1 | < 0.1% |
| 0.059481 | 1 | < 0.1% |
| 0.117036 | 1 | < 0.1% |
| 0.261984 | 1 | < 0.1% |
| 0.311953 | 1 | < 0.1% |
| 0.319475 | 1 | < 0.1% |
| 1.113027 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 76406.20752 | 1 | |
| 61031.6186 | 1 | |
| 56370.04117 | 1 | |
| 50260.75947 | 1 | |
| 43132.72823 | 1 | |
| 42629.55117 | 1 | |
| 38512.12477 | 1 | |
| 31871.36379 | 1 | |
| 30528.4324 | 1 | |
| 29019.80288 | 1 |
| Distinct | 47 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.153857934 |
| Minimum | 0 |
|---|---|
| Maximum | 1 |
| Zeros | 5878 |
| Zeros (%) | 65.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 69.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0.142857 |
| 95-th percentile | 1 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range (IQR) | 0.142857 |
Descriptive statistics
| Standard deviation | 0.2925724792 |
|---|---|
| Coefficient of variation (CV) | 1.901575509 |
| Kurtosis | 2.428781777 |
| Mean | 0.153857934 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.941892824 |
| Sum | 1372.412771 |
| Variance | 0.08559865557 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 5878 | |
| 1 | 487 | 5.5% |
| 0.083333 | 426 | 4.8% |
| 0.166667 | 166 | 1.9% |
| 0.25 | 156 | 1.7% |
| 0.5 | 155 | 1.7% |
| 0.090909 | 153 | 1.7% |
| 0.333333 | 133 | 1.5% |
| 0.1 | 94 | 1.1% |
| 0.2 | 83 | 0.9% |
| Other values (37) | 1189 | 13.3% |
| Value | Count | Frequency (%) |
| 0 | 5878 | |
| 0.083333 | 426 | 4.8% |
| 0.090909 | 153 | 1.7% |
| 0.1 | 94 | 1.1% |
| 0.111111 | 61 | 0.7% |
| 0.125 | 52 | 0.6% |
| 0.142857 | 54 | 0.6% |
| 0.166667 | 166 | 1.9% |
| 0.181818 | 75 | 0.8% |
| 0.2 | 83 | 0.9% |
| Value | Count | Frequency (%) |
| 1 | 487 | |
| 0.916667 | 77 | 0.9% |
| 0.909091 | 19 | 0.2% |
| 0.9 | 16 | 0.2% |
| 0.888889 | 12 | 0.1% |
| 0.875 | 18 | 0.2% |
| 0.857143 | 12 | 0.1% |
| 0.833333 | 62 | 0.7% |
| 0.818182 | 17 | 0.2% |
| 0.8 | 33 | 0.4% |
tenure
Real number (ℝ≥0)
| Distinct | 7 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.52073991 |
| Minimum | 6 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 69.8 KiB |
Quantile statistics
| Minimum | 6 |
|---|---|
| 5-th percentile | 8 |
| Q1 | 12 |
| median | 12 |
| Q3 | 12 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 6 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.332919677 |
|---|---|
| Coefficient of variation (CV) | 0.115697402 |
| Kurtosis | 7.777202151 |
| Mean | 11.52073991 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -2.955438266 |
| Sum | 102765 |
| Variance | 1.776674865 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 12 | 7565 | |
| 11 | 364 | 4.1% |
| 10 | 234 | 2.6% |
| 6 | 200 | 2.2% |
| 8 | 194 | 2.2% |
| 7 | 189 | 2.1% |
| 9 | 174 | 2.0% |
| Value | Count | Frequency (%) |
| 6 | 200 | 2.2% |
| 7 | 189 | 2.1% |
| 8 | 194 | 2.2% |
| 9 | 174 | 2.0% |
| 10 | 234 | 2.6% |
| 11 | 364 | 4.1% |
| 12 | 7565 |
| Value | Count | Frequency (%) |
| 12 | 7565 | |
| 11 | 364 | 4.1% |
| 10 | 234 | 2.6% |
| 9 | 174 | 2.0% |
| 8 | 194 | 2.2% |
| 7 | 189 | 2.1% |
| 6 | 200 | 2.2% |
| Distinct | 6171 |
|---|---|
| Distinct (%) | 69.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 73.92179897 |
| Minimum | 0 |
|---|---|
| Maximum | 5981.666667 |
| Zeros | 2038 |
| Zeros (%) | 22.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 69.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 12 |
| median | 41.42833333 |
| Q3 | 78.810375 |
| 95-th percentile | 228.5795238 |
| Maximum | 5981.666667 |
| Range | 5981.666667 |
| Interquartile range (IQR) | 66.810375 |
Descriptive statistics
| Standard deviation | 160.6366626 |
|---|---|
| Coefficient of variation (CV) | 2.17306214 |
| Kurtosis | 265.0401262 |
| Mean | 73.92179897 |
| Median Absolute Deviation (MAD) | 34.08204617 |
| Skewness | 11.50961785 |
| Sum | 659382.4468 |
| Variance | 25804.13738 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 2038 | 22.8% |
| 50 | 30 | 0.3% |
| 45.65 | 27 | 0.3% |
| 60 | 22 | 0.2% |
| 100 | 17 | 0.2% |
| 25 | 16 | 0.2% |
| 40 | 15 | 0.2% |
| 20 | 11 | 0.1% |
| 90 | 11 | 0.1% |
| 45 | 10 | 0.1% |
| Other values (6161) | 6723 |
| Value | Count | Frequency (%) |
| 0 | 2038 | |
| 0.01 | 4 | < 0.1% |
| 0.05 | 1 | < 0.1% |
| 0.7 | 2 | < 0.1% |
| 0.7 | 3 | < 0.1% |
| 1 | 3 | < 0.1% |
| 1.48 | 1 | < 0.1% |
| 2 | 1 | < 0.1% |
| 2.783333333 | 1 | < 0.1% |
| 2.856 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 5981.666667 | 1 | |
| 2900 | 1 | |
| 2600 | 1 | |
| 2523.438 | 1 | |
| 2483.26 | 1 | |
| 2190 | 1 | |
| 2000 | 2 | |
| 1875 | 1 | |
| 1865.044 | 1 | |
| 1810 | 1 |
| Distinct | 4309 |
|---|---|
| Distinct (%) | 48.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 209.2463055 |
| Minimum | 0 |
|---|---|
| Maximum | 14836.45141 |
| Zeros | 4612 |
| Zeros (%) | 51.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 69.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 247.4883825 |
| 95-th percentile | 927.0156037 |
| Maximum | 14836.45141 |
| Range | 14836.45141 |
| Interquartile range (IQR) | 247.4883825 |
Descriptive statistics
| Standard deviation | 536.4028126 |
|---|---|
| Coefficient of variation (CV) | 2.563499563 |
| Kurtosis | 155.1960689 |
| Mean | 209.2463055 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 9.618200794 |
| Sum | 1866477.045 |
| Variance | 287727.9774 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 4612 | |
| 340.249539 | 1 | < 0.1% |
| 102.5884456 | 1 | < 0.1% |
| 1603.404898 | 1 | < 0.1% |
| 753.31351 | 1 | < 0.1% |
| 364.0986716 | 1 | < 0.1% |
| 1851.237848 | 1 | < 0.1% |
| 908.434086 | 1 | < 0.1% |
| 181.3516184 | 1 | < 0.1% |
| 338.3941967 | 1 | < 0.1% |
| Other values (4299) | 4299 |
| Value | Count | Frequency (%) |
| 0 | 4612 | |
| 14.222216 | 1 | < 0.1% |
| 18.042768 | 1 | < 0.1% |
| 18.1014785 | 1 | < 0.1% |
| 18.117967 | 1 | < 0.1% |
| 18.123413 | 1 | < 0.1% |
| 18.126347 | 1 | < 0.1% |
| 18.126683 | 1 | < 0.1% |
| 18.149946 | 1 | < 0.1% |
| 18.1543055 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 14836.45141 | 1 | |
| 10590.41113 | 1 | |
| 9798.167329 | 1 | |
| 9671.336737 | 1 | |
| 9553.955906 | 1 | |
| 7968.273359 | 1 | |
| 7894.578816 | 1 | |
| 7714.493122 | 1 | |
| 7413.65358 | 1 | |
| 7378.253685 | 1 |
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| df_index | cust_id | balance | balance_frequency | purchases | oneoff_purchases | installments_purchases | cash_advance | purchases_frequency | oneoff_purchases_frequency | purchases_installments_frequency | cash_advance_frequency | cash_advance_trx | purchases_trx | credit_limit | payments | minimum_payments | prc_full_payment | tenure | purchases_avg | cash_advance_avg | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | 10001 | 40.900749 | 0.818182 | 95.40 | 0.00 | 95.40 | 0.000000 | 0.166667 | 0.000000 | 0.083333 | 0.000000 | 0 | 2 | 1000.0 | 201.802084 | 139.509787 | 0.000000 | 12 | 47.700000 | 0.000000 |
| 1 | 1 | 10002 | 3202.467416 | 0.909091 | 0.00 | 0.00 | 0.00 | 6442.945483 | 0.000000 | 0.000000 | 0.000000 | 0.250000 | 4 | 0 | 7000.0 | 4103.032597 | 1072.340217 | 0.222222 | 12 | 0.000000 | 1610.736371 |
| 2 | 2 | 10003 | 2495.148862 | 1.000000 | 773.17 | 773.17 | 0.00 | 0.000000 | 1.000000 | 1.000000 | 0.000000 | 0.000000 | 0 | 12 | 7500.0 | 622.066742 | 627.284787 | 0.000000 | 12 | 64.430833 | 0.000000 |
| 3 | 3 | 10004 | 1666.670542 | 0.636364 | 1499.00 | 1499.00 | 0.00 | 205.788017 | 0.083333 | 0.083333 | 0.000000 | 0.083333 | 1 | 1 | 7500.0 | 0.000000 | 0.000000 | 0.000000 | 12 | 1499.000000 | 205.788017 |
| 4 | 4 | 10005 | 817.714335 | 1.000000 | 16.00 | 16.00 | 0.00 | 0.000000 | 0.083333 | 0.083333 | 0.000000 | 0.000000 | 0 | 1 | 1200.0 | 678.334763 | 244.791237 | 0.000000 | 12 | 16.000000 | 0.000000 |
| 5 | 5 | 10006 | 1809.828751 | 1.000000 | 1333.28 | 0.00 | 1333.28 | 0.000000 | 0.666667 | 0.000000 | 0.583333 | 0.000000 | 0 | 8 | 1800.0 | 1400.057770 | 2407.246035 | 0.000000 | 12 | 166.660000 | 0.000000 |
| 6 | 6 | 10007 | 627.260806 | 1.000000 | 7091.01 | 6402.63 | 688.38 | 0.000000 | 1.000000 | 1.000000 | 1.000000 | 0.000000 | 0 | 64 | 13500.0 | 6354.314328 | 198.065894 | 1.000000 | 12 | 110.797031 | 0.000000 |
| 7 | 7 | 10008 | 1823.652743 | 1.000000 | 436.20 | 0.00 | 436.20 | 0.000000 | 1.000000 | 0.000000 | 1.000000 | 0.000000 | 0 | 12 | 2300.0 | 679.065082 | 532.033990 | 0.000000 | 12 | 36.350000 | 0.000000 |
| 8 | 8 | 10009 | 1014.926473 | 1.000000 | 861.49 | 661.49 | 200.00 | 0.000000 | 0.333333 | 0.083333 | 0.250000 | 0.000000 | 0 | 5 | 7000.0 | 688.278568 | 311.963409 | 0.000000 | 12 | 172.298000 | 0.000000 |
| 9 | 9 | 10010 | 152.225975 | 0.545455 | 1281.60 | 1281.60 | 0.00 | 0.000000 | 0.166667 | 0.166667 | 0.000000 | 0.000000 | 0 | 3 | 11000.0 | 1164.770591 | 100.302262 | 0.000000 | 12 | 427.200000 | 0.000000 |
Last rows
| df_index | cust_id | balance | balance_frequency | purchases | oneoff_purchases | installments_purchases | cash_advance | purchases_frequency | oneoff_purchases_frequency | purchases_installments_frequency | cash_advance_frequency | cash_advance_trx | purchases_trx | credit_limit | payments | minimum_payments | prc_full_payment | tenure | purchases_avg | cash_advance_avg | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8910 | 8940 | 19181 | 130.838554 | 1.000000 | 591.24 | 0.00 | 591.24 | 0.000000 | 1.000000 | 0.000000 | 0.833333 | 0.000000 | 0 | 6 | 1000.0 | 475.523262 | 82.771320 | 1.00 | 6 | 98.540000 | 0.000000 |
| 8911 | 8941 | 19182 | 5967.475270 | 0.833333 | 214.55 | 0.00 | 214.55 | 8555.409326 | 0.833333 | 0.000000 | 0.666667 | 0.666667 | 13 | 5 | 9000.0 | 966.202912 | 861.949906 | 0.00 | 6 | 42.910000 | 658.108410 |
| 8912 | 8942 | 19183 | 40.829749 | 1.000000 | 113.28 | 0.00 | 113.28 | 0.000000 | 1.000000 | 0.000000 | 0.833333 | 0.000000 | 0 | 6 | 1000.0 | 94.488828 | 86.283101 | 0.25 | 6 | 18.880000 | 0.000000 |
| 8913 | 8943 | 19184 | 5.871712 | 0.500000 | 20.90 | 20.90 | 0.00 | 0.000000 | 0.166667 | 0.166667 | 0.000000 | 0.000000 | 0 | 1 | 500.0 | 58.644883 | 43.473717 | 0.00 | 6 | 20.900000 | 0.000000 |
| 8914 | 8944 | 19185 | 193.571722 | 0.833333 | 1012.73 | 1012.73 | 0.00 | 0.000000 | 0.333333 | 0.333333 | 0.000000 | 0.000000 | 0 | 2 | 4000.0 | 0.000000 | 0.000000 | 0.00 | 6 | 506.365000 | 0.000000 |
| 8915 | 8945 | 19186 | 28.493517 | 1.000000 | 291.12 | 0.00 | 291.12 | 0.000000 | 1.000000 | 0.000000 | 0.833333 | 0.000000 | 0 | 6 | 1000.0 | 325.594462 | 48.886365 | 0.50 | 6 | 48.520000 | 0.000000 |
| 8916 | 8946 | 19187 | 19.183215 | 1.000000 | 300.00 | 0.00 | 300.00 | 0.000000 | 1.000000 | 0.000000 | 0.833333 | 0.000000 | 0 | 6 | 1000.0 | 275.861322 | 0.000000 | 0.00 | 6 | 50.000000 | 0.000000 |
| 8917 | 8947 | 19188 | 23.398673 | 0.833333 | 144.40 | 0.00 | 144.40 | 0.000000 | 0.833333 | 0.000000 | 0.666667 | 0.000000 | 0 | 5 | 1000.0 | 81.270775 | 82.418369 | 0.25 | 6 | 28.880000 | 0.000000 |
| 8918 | 8948 | 19189 | 13.457564 | 0.833333 | 0.00 | 0.00 | 0.00 | 36.558778 | 0.000000 | 0.000000 | 0.000000 | 0.166667 | 2 | 0 | 500.0 | 52.549959 | 55.755628 | 0.25 | 6 | 0.000000 | 18.279389 |
| 8919 | 8949 | 19190 | 372.708075 | 0.666667 | 1093.25 | 1093.25 | 0.00 | 127.040008 | 0.666667 | 0.666667 | 0.000000 | 0.333333 | 2 | 23 | 1200.0 | 63.165404 | 88.288956 | 0.00 | 6 | 47.532609 | 63.520004 |